package com.casi.project.portal.mapper;

import com.casi.project.portal.domain.MobileHomeMenu;
import com.casi.project.portal.domain.MobileHomeMenuDetails;
import com.casi.project.portal.vo.NoticeVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Auther shp
 * @data2020/4/1510:31
 * @description
 */

@Mapper
public interface IndexApiMapper {


    @Select("SELECT m.id,m.title,m.push_time pushTime,m.notices FROM mobile_notice m where is_show=0 and is_online=0 ORDER BY m.id desc;")
    List<NoticeVO> findNotice();

    @Select("SELECT u.id,u.menu_name menuName,u.parent_id parentId,u.skip_url skipUrl,u.create_time createTime,update_time updateTime FROM mobile_home_menu u ORDER BY menu_sort DESC;")
    List<MobileHomeMenu> findHomeMenu();

    @Select("SELECT s.menu_button_name menuButtonName,s.button_parent_id buttonParentId FROM mobile_home_menu_details s;")
    List<MobileHomeMenuDetails> findMobileHomeMenuDetails();



}
